ABSTRACT
Objective To upgrade No.1 Military Medical Project database from Oracle 8.17 to Oracle 11g so as to solve the problems of server overloading and client terminal failing to connect to the server due to excessive concurrent databases. Methods Exp/Imp and Toad tools of the database were used to generate and modify the upgrade statements as well as to import and export database data,so that the inter-platform and-version database upgrade could be carried out.Results The database was upgraded and the system's operation speed was enhanced greatly.Conclusion The upgrade scheme has easy operation,short time consumed,zero data loss and high reliability,and thus is worthy promoting in medium-and small-scale hospitals.
ABSTRACT
Objective To develop a PACS covering the whole hospital.Methods Communication between PACS and the existing HIS was realized with Web technology,SOA,Oracle database and barcode technology.esults The electronic information from HIS contributed to real-time,automatic and one-to-one charging by PACS,and the examining results and images were returned to HIS to implement the integration of data set,application set and flow set,and statistical analysis was carried out on the examining results,then a set of PACS/RIS with complete functions came into being.Conclusion PACS/RIS simplifies the process for visiting a doctor,decreases waiting time,transmits data on the detection equipment in time and implements paperless image report.
ABSTRACT
Objective:To convert the HIS database character set into ZHS16GBK code in order to ensure Chinese character can be normally displayed after data were imported.Methods: Used the tool and text editor to complete the conversion of database character set which based on the basis of database character set and the functions of database import and export procedures. Results:By actual test, this research provide a set of technology solutions can upgrade character set and avoid Chinese display garbled.Conclusion:In order to avoid Chinese characters display garbled, actual test of character set would been finished before the database version is upgraded.
ABSTRACT
Objective To explore the migration of Windows operating system to Virtual Linux operation system to solve the problems faced by the main server of No.1 Military Medical Project HIS.Methods The migration was fulfilled with x86 hardware platform,open-source Linux operating system and virtualization technology to meet the performance and reliability requirements of No.1 Military Medical Project System.Results The migration was completed successfully to Virtual Linux system.Conclusion The migration scheme meets the requirements of HIS on performances,reliability,stability and safety,saves the cost for informatization,and is of great practical value.
ABSTRACT
Objective To upgrade No.1 Military Medical Project from single operation to Oracle RAC to eliminate single failure of the operation system, protect medical data and lay a foundation for the following upgrade and deployment.Methods RAC software and hardware environment was constructed for database upgrade and deployment of Data Guard.Results The database was gifted with high availability and high performances, and database maintenance and upgrade could be carried out with the operation system less ceased than before.Conclusion The database is upgraded from a single-mode rigid architecture to a multi-mode elastic one, with the performances, safety and extendibility enhanced greatly.
ABSTRACT
Objective Since it is a common problem for medical practice that paper instructions for medicine information are difficult to update and inconvenient to search ,this article is to provide convenient service of pharmacy information for clini-cal practice by developing medicine information search software in our hospital .Methods According to the practical needs of clinical study and pharmacy research ,we took appropriate measures to collect data ,categorize contents ,scan pictures ,polish images and extract information for the medicine instructions .Based on the above work ,we applied Oracle 10G to establish medicine information database for our hospital and utilized Java to design medicine information search software .Results Our search software includes 1 201 kinds of medicines ,taking up 98 .85% of the medicines in our catalogue .The users can use four different search methods (including common name search ,commodity name search ,fuzzy search and key word search) to gain the written material and photographic information of medicine instructions .Conclusion With the help of the software of Oracle and Java ,the newly designed software for medicine information search can provide convenient pharmacy information service for clinical practice .
ABSTRACT
Objective To improve the data storage performance of Oracle database and simplify data storage management in No.1 Military Medical Project.Methods Using the automatic storage management provided by Oracle 10g,Oracle database in No.1 Military Medical Project was upgraded to Oracle 10g,and then the upgraded Oracle database was migrated to Oracle automatic storage management system.At last,all kinds of tests were made to the Oracle automatic storage management system.Results Oracle automatic storage management system greatly simplified data storage management in such aspects as automatic disk striping,automatic datafile mirroring,automatic disk loads rebalancing,etc.Conclusion This method is simple and feasible with low cost.
ABSTRACT
The performance of Oracle database directly affects the running of hospital information system.Through the systematic study of Oracle index,this paper elucidates how to correctly use the index including the setting and using of Oracle index.
ABSTRACT
Aiming at different Oracle database editions, this paper puts forwards several recovery solutions, including the technology of point-in-time recovery, redo logminer, and database flashback.
ABSTRACT
This article discusses how to handle one or more block corruptions on an Oracle data file and describes some main methods for data extraction.
ABSTRACT
This paper introduces the safe realization of ″No.1 Military″ database upgrade from ORACLE7.33 to ORACLE8I by import/export tools based on standby server.The establishment of standby server and the process of No.1 Military database upgrade are introduced detailedly in this paper.The database upgrade of other application system adopting ORACLE database system can refer to this paper.
ABSTRACT
Objective To explore the cause of repeated offline of files in the database of No.1 Military Project and find the method to solve the problem. Methods The abnormal offline of files in database is not by chance,and its document in oracle is not very clear. Using the knowledge from internet,the fault was repeatedly simulated on test machine and the source of the fault was found. Results Solving plans and countermeasures were put forward. Conclusion The database of the No.1 Military Medical Project is the core of military hospital work,so its importance is self-evident. The technical support of No. 1 Military Project is strengthened,the right maintenance direction of the database is pointed out as well as the right solution to deal with the problem.
ABSTRACT
Objective To prevent data transfer or loss in application development when dealing with data exchange between Oracle database with different server's character set.Methods Environment variable is set to update Oracle client's character set so as to solve data transfer or loss caused by character set transformation.Results It was the environment variable not the register list that was reset,so Oracle databases with different server's character set were not connected at the same time.Conclusion An adaptive method for different server's character set is given to solve this problem.
ABSTRACT
With the increment of the workload,high stability is required by hospital information system.When the amount of client exceeds the limit,we must reconstruct the Oracle server in order to meet the needs of workload increment.This article describes the principle of shared server and the reconstructed method from dedicated server to multithreaded server.
ABSTRACT
This paper introduces the backup and recovery of ORACLE database in HIS from the aspects of ORACLE setup, logical backup and recovery as well as physical backup and recovery. With the experience of the 175th hospital as an example, the method for the design and realization of the backup is put forward.
ABSTRACT
Objective To quickly pinpoint and correct errors in the application level in No.1 Military Medical Project. Methods LogMiner, a powerful tool provided by Oracle was used to mine and analyze the redo log files produced by oracle database in No.1 Military Medical Project. The basic concept, configuration and usage of LogMiner were described through an example of the Register Program in No.1 Military Medical Project. Results The errors made by Register Program was quickly pinpointed and then corrected by SQL statements provided by UNDO_VALUE field. Conclusion The method using LogMiner to pinpoint and correct the errors in the application level in No.1 Military Medical Project is simple, accurate and convenient. It should be a basic technique for maintenance personnel of hospital information system.
ABSTRACT
Objective To discuss the influence of Open resetlogs on Oracle database recovery. Methods Database backup was used to recover database before resetlogs. Before Oracle 9i, Oracle database was recovered through two steps; after Oracle10g, Oracle archived redo log by new format. Results Both methods could recover Oracle database by using backups before resetlogs. Conclusion Before Oracle9i, the recovery steps are complex, so it is suggested a consistent database backup should be made after resetlogs. By using the new archived redo log format after Oracle10g, it is easy to recover database through resetlogs.
ABSTRACT
Objective To upgrade No.1 Military Medial Project database from Oracle8.17 to Oracle10g. Methods Through the establishment of database link, the database migration was realized based on full test's foundation. Results The database was upgraded and the system's operation speed was enhanced greatly. Conclusion Under the existing technology, it is feasible to upgrade Oracle database from Oracle8.17 in 32 bits to Oracle10g in 64 bits, and the benefit is remarkable.
ABSTRACT
This paper describes the security defects of No.1 Military Medical Project,introduces the Oracle database event trigger,and presents a method to improve the security of HIS by using the trigger.
ABSTRACT
Objective To discuss the ideas and specific implementation steps of Oracle database upgrading.Methods By using the EXP and IMP which are provided by the Oracle database,import and export of entire database are implemented and complete database upgrading.Results The database is upgraded form Oracle 8i to Oracle 10g,which is the foundation of our hospital follow-up implementation of PACS and RAC technology.Conclusion Because the environment of practical application is different and complex,the Oracle database must test before the upgrading;the appropriate parameters are set according to different front-end application environment,and then enhance server performance significantly.